package util;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

public class ConexionExcel {

	/*
	public static Connection obtenerConexion() throws SQLException, ClassNotFoundException {
	Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
	Connection conexion = DriverManager.getConnection("jdbc:odbc:"+"C:\\FORMATO_LISTA_PRECIOS.xlsx");
	return conexion;
	}
	
	public static void listar() throws SQLException, ClassNotFoundException{
		Connection conexion = obtenerConexion();
		Statement st = conexion.createStatement();
		ResultSet rs = st.executeQuery("select * from LISTA_PRECIOS");
		while(rs.next()){
			System.out.println(rs.getString(1));
		}
		
		rs.close();
		st.close();
		conexion.close();
	}
	*/
}
